ALTER TABLE X_HIER_NODE_TYPES ADD IMG_URL NVARCHAR(MAX)
BEGIN TRAN

UPDATE X_HIER_NODE_TYPES 
SET IMG_URL = '../NodeImages/root.png'
WHERE  HIERARCHY_ID = 1 AND NODE_TYPE_ID = 0

UPDATE X_HIER_NODE_TYPES 
SET IMG_URL = '../NodeImages/folder.png'
WHERE  HIERARCHY_ID = 1 AND NODE_TYPE_ID = 1

UPDATE X_HIER_NODE_TYPES 
SET IMG_URL = '../NodeImages/folder.png'
WHERE  HIERARCHY_ID = 1 AND NODE_TYPE_ID = 2

UPDATE X_HIER_NODE_TYPES 
SET IMG_URL = '../NodeImages/file.png'
WHERE  HIERARCHY_ID = 1 AND NODE_TYPE_ID = 3

COMMIT TRAN